<!doctype html>

<html lang="en">

 <head>

  <meta charset="UTF-8">  

  <title>用户列表</title>

  <link rel="stylesheet" type="text/css" href="../css/bootstrap.min.css">

 </head>

 <body>

 

 <?php

  require_once('inc_admin.php');

  require_once('menu.php');

  connect();

  //编写sql语句

  $sql = 'select uid, uname, gender, birthdate, hobby, degree, intro, pic from users';

  //echo $sql.'<br/>';  

  $result = fetch_array($sql); 

   

 ?>

 <div class="container">

   <div class="row">

     <h1 class="text-center">用户列表</h1>

     <table class="table table-hover"> 

     <tr>

       <th>用户编号</th>

       <th>用户名</th>   

       <th>性别</th>

       <th>生日</th>

       <th>爱好</th>

       <th>学历</th>

       <th>自我介绍</th> 

       <th width='80'>头像</th>

       <th>操作</th>

     </tr>



     <?php

      foreach ($result as $row) {

       echo '<tr>';

       echo '<td>'.$row['uid'].'</td>';

       echo '<td>'.$row['uname'].'</td>';  

       echo '<td>'.($row['gender']==0?'男':'女').'</td>';

       echo '<td>'.$row['birthdate'].'</td>';

       echo '<td>'.$row['hobby'].'</td>';

       switch($row['degree']){

         case '1':$dg = "高中";break;

         case '2':$dg = "大学";break;

         case '3':$dg = "研究生";break;

         case '4':$dg = "博士生";break;

         default: $dg="不知道";

         }

       echo '<td>'.$dg.'</td>';

       echo '<td>'.$row['intro'].'</td>';    

       echo '<td align="center"><img src='.$row['pic'].' width=60 height=80 alt="无头像"></td>';  

       echo '<td><a href="userEditForm.php?id='.$row['uid'].' ">修改</a> | 

       <a href="userDelete.php?id='.$row['uid'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';

       echo '</tr>';  

      }

      echo '</table>';  

      $totalrows = count($result);

      echo "<table align='center'><tr><td>共有{$totalrows}名用户</td></tr></table>";   

     ?>

  </div>

 </div>

 </body>

</html>

